Stored Procedures [dbo].[BAEImisOrderLineGetAll]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ORDER_NUMBERfloat8
SQL Script
create procedure [dbo].[BAEImisOrderLineGetAll] @ORDER_NUMBER as
float
AS
    SELECT *
    FROM Order_Lines
    WHERE ORDER_NUMBER    =    @ORDER_NUMBER
    ORDER BY LINE_NUMBER;

GO
Uses